CREATE TABLE [dbo].[SiteUserExtended]
(
[UserId] [int] NOT NULL,
[FirstName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NULL,
[MiddleName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NULL,
[LastName] [nvarchar] (50) COLLATE Cyrillic_General_CI_AS NULL,
[JobId] [int] NULL,
[JobPosition] [nvarchar] (200) COLLATE Cyrillic_General_CI_AS NULL,
[BirthDate] [datetime] NULL,
[Phone1] [nvarchar] (100) COLLATE Cyrillic_General_CI_AS NULL,
[Phone2] [nvarchar] (100) COLLATE Cyrillic_General_CI_AS NULL,
[ICQ] [nvarchar] (15) COLLATE Cyrillic_General_CI_AS NULL,
[Skype] [nvarchar] (100) COLLATE Cyrillic_General_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SiteUserExtended] ADD CONSTRAINT [PK_SiteUser_Extended] PRIMARY KEY CLUSTERED  ([UserId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SiteUserExtended] ADD CONSTRAINT [FK_SiteUser_Extended_Job] FOREIGN KEY ([JobId]) REFERENCES [dbo].[Job] ([JobId])
GO
